Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners

ICTPRG403 Mapping and Delivery Guide
Develop data-driven applications

Version 1.0
Issue Date: May 2024


Qualification -
Unit of Competency ICTPRG403 - Develop data-driven applications
Description
Employability Skills
Learning Outcomes and Application This unit describes the skills and knowledge required to create data-driven applications that access data from a range of sources, such as databases, object data sources or eXtensible markup language (XML).It applies to individuals who may work as programmers or database application developers and who are responsible for data-access coding.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Duration and Setting X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting.

Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the programming and software development field of work and include access to:

integrated development environment (IDE)

data access application program interfaces (APIs)

database management system software and files

coding standard

specific tools and licences, depending on particular data-access API

different types of data-access methods including data retrieval and storage, back-end coding and disconnect data management

eXtensible markup language (XML) documents.

Assessors must satisfy NVR/AQTF assessor requirements.
Prerequisites/co-requisites
Competency Field
Development and validation strategy and guide for assessors and learners Student Learning Resources Handouts
Activities 		Slides
PPT 		Assessment 1 Assessment 2 Assessment 3 Assessment 4
Elements of Competency Performance Criteria              
Element: Select data-access layer (DAL)
  • Review function of DAL in multi-layer application model
  • Determine data-access application programming interface (API) for connecting to various data sources
       
Element: Establish connection with data source
  • Create and manage connection strings
  • Connect to data source by using different data providers
  • Create code to handle connection exceptions
       
Element: Execute commands and return results from data source
  • Query data from data source
  • Retrieve data from data source as result sets
  • Manage result sets
  • Manage exceptions when retrieving data
       
Element: Modify data in data source
  • Insert, update or delete data
  • Manage data integrity
  • Manage exceptions when modifying data
       
Element: Manage disconnected data
  • Research disconnected data management strategy
  • Ensure that application can deal with disconnected data
       
Element: Document data-access layer
  • Document code
  • Document database connectivity
       


Evidence Required

List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Select data-access layer (DAL)

1.1 Review function of DAL in multi-layer application model

1.2 Determine data-access application programming interface (API) for connecting to various data sources

2. Establish connection with data source

2.1 Create and manage connection strings

2.2 Connect to data source by using different data providers

2.3 Create code to handle connection exceptions

3. Execute commands and return results from data source

3.1 Query data from data source

3.2 Retrieve data from data source as result sets

3.3 Manage result sets

3.4 Manage exceptions when retrieving data

4. Modify data in data source

4.1 Insert, update or delete data

4.2 Manage data integrity

4.3 Manage exceptions when modifying data

5. Manage disconnected data

5.1 Research disconnected data management strategy

5.2 Ensure that application can deal with disconnected data

6. Document data-access layer

6.1 Document code

6.2 Document database connectivity

Evidence of the ability to:

select and code the data-access layer of multi-layer applications

retrieve and update data from various data sources.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual must:

describe the features of object-oriented design and multi-layer applications

outline relational database management systems

describe object-oriented programming at an intermediate level

outline the principles of a Structured Query Language (SQL).

Submission Requirements

List each assessment task's title, type (eg project, observation/demonstration, essay, assignment, checklist) and due date here

Assessment task 1: [title]      Due date:

(add new lines for each of the assessment tasks)

Assessment Tasks

Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Select data-access layer (DAL)

1.1 Review function of DAL in multi-layer application model

1.2 Determine data-access application programming interface (API) for connecting to various data sources

2. Establish connection with data source

2.1 Create and manage connection strings

2.2 Connect to data source by using different data providers

2.3 Create code to handle connection exceptions

3. Execute commands and return results from data source

3.1 Query data from data source

3.2 Retrieve data from data source as result sets

3.3 Manage result sets

3.4 Manage exceptions when retrieving data

4. Modify data in data source

4.1 Insert, update or delete data

4.2 Manage data integrity

4.3 Manage exceptions when modifying data

5. Manage disconnected data

5.1 Research disconnected data management strategy

5.2 Ensure that application can deal with disconnected data

6. Document data-access layer

6.1 Document code

6.2 Document database connectivity

Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.

Observation Checklist

Tasks to be observed according to workplace/college/TAFE policy and procedures, relevant legislation and Codes of Practice Yes No Comments/feedback
Review function of DAL in multi-layer application model 
Determine data-access application programming interface (API) for connecting to various data sources 
Create and manage connection strings 
Connect to data source by using different data providers 
Create code to handle connection exceptions 
Query data from data source 
Retrieve data from data source as result sets 
Manage result sets 
Manage exceptions when retrieving data 
Insert, update or delete data 
Manage data integrity 
Manage exceptions when modifying data 
Research disconnected data management strategy 
Ensure that application can deal with disconnected data 
Document code 
Document database connectivity 

Forms

Assessment Cover Sheet

ICTPRG403 - Develop data-driven applications
Assessment task 1: [title]

Student name:

Student ID:

I declare that the assessment tasks submitted for this unit are my own work.

Student signature:

Result: Competent Not yet competent

Feedback to student

 

 

 

 

 

 

 

 

Assessor name:

Signature:

Date:

Assessment Record Sheet

ICTPRG403 - Develop data-driven applications

Student name:

Student ID:

Assessment task 1: [title] Result: Competent Not yet competent

(add lines for each task)

Feedback to student:

 

 

 

 

 

 

 

 

Overall assessment result: Competent Not yet competent

Assessor name:

Signature:

Date:

Student signature:

Date: